SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwbdivisionesacerrar
AS
SELECT     dbo.tb_DivisionesACerrar.IdDivision AS ID, dbo.tb_DivisionesACerrar.Reestructura AS Reestructura, dbo.tb_DivisionesACerrar.DivisionACerrar, 
                      dbo.tb_EstadosDeReestructura.Descripcion
FROM         dbo.tb_EstadosDeReestructura INNER JOIN
                      dbo.tb_DivisionesACerrar ON dbo.tb_EstadosDeReestructura.idEstadoReestructura = dbo.tb_DivisionesACerrar.Estado INNER JOIN
                      dbo.tb_Reestructuras ON dbo.tb_DivisionesACerrar.Reestructura = dbo.tb_Reestructuras.IDReestructura
GO
GRANT SELECT ON  [dbo].[vwbdivisionesacerrar] TO [Informatica]
GRANT INSERT ON  [dbo].[vwbdivisionesacerrar] TO [Informatica]
GRANT DELETE ON  [dbo].[vwbdivisionesacerrar] TO [Informatica]
GRANT UPDATE ON  [dbo].[vwbdivisionesacerrar] TO [Informatica]
GRANT SELECT ON  [dbo].[vwbdivisionesacerrar] TO [SoloVer]
GO
